SAS Data Integration Studio jobs that contain an SQL Set, Update, or Delete transformation that contains a subquery definition might lose the subquery metadata after you run the Analyze and Repair Metadata Tool in SAS^® Management Console.

The loss of metadata can occur when the Analyze Metadata Tool incorrectly determines subquery metadata to be Orphaned Job Metadata. When the Repair component of the tool is run to correct the Orphaned Job Metadata, the subquery metadata is deleted, which removes the subquery definition from within the transformation.

For additional information, see SAS Note 54671: "The Orphaned Job Metadata tool might remove valid targetTransformation objects."

A workaround to this issue is not to run the Repair Metadata Tool against Orphaned Job Metadata.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Data Integration Studio	Windows 7 Professional 32 bit	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Windows 7 Home Premium x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Windows 7 Home Premium 32 bit	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Windows 7 Enterprise x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Windows 7 Enterprise 32 bit	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows Server 2012 Std	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows Server 2012 R2 Std	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows Server 2012 R2 Datacenter	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows Server 2012 Datacenter	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows Server 2008 for x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows Server 2008 R2	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows Server 2008	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows 8.1 Pro 32-bit	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows 8.1 Pro	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows 8.1 Enterprise x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows 8.1 Enterprise 32-bit	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows 8 Pro x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows 8 Pro 32-bit	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows 8 Enterprise x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft® Windows® for x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Windows 7 Ultimate x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Windows 7 Professional x64	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Windows 7 Ultimate 32 bit	4.9	4.902	9.4 TS1M2	9.4 TS1M4
		Microsoft Windows 8 Enterprise 32-bit	4.9	4.902	9.4 TS1M2	9.4 TS1M4

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

A fix for this issue for SAS Middle Tier 9.4_M3 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/V10.html#57131

---

A fix for this issue for SAS Management Console 9.4_M3 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/V11.html#57131

---

A fix for this issue for Data Integration Studio 4.901 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/W51.html#57131

---

A fix for this issue for SAS Middle Tier 9.4_M2 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/R75.html#57131

---

A fix for this issue for SAS Management Console 9.4_M2 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/R76.html#57131

---

A fix for this issue for SAS Management Console 9.3_M2 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/I15.html#57131

---

SAS Data Integration Studio jobs that contain the SQL Set, Update, or Delete transformations might lose subquery metadata definitions after you run the Analyze and Repair Metadata tool in SAS® Management Console.

Type:	Problem Note
Priority:	high

Date Modified:	2016-01-20 10:03:47
Date Created:	2015-11-23 12:36:23